/*
 Navicat Premium Data Transfer

 Source Server         : lc
 Source Server Type    : MySQL
 Source Server Version : 50626
 Source Host           : localhost
 Source Database       : vote2016qingxie

 Target Server Type    : MySQL
 Target Server Version : 50626
 File Encoding         : utf-8

 Date: 03/17/2016 15:48:53 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `Academy`
-- ----------------------------
DROP TABLE IF EXISTS `Academy`;
CREATE TABLE `Academy` (
  `Aid` int(11) NOT NULL AUTO_INCREMENT,
  `Aname` varchar(255) NOT NULL,
  `Avote` int(11) NOT NULL,
  `Aimg` varchar(255) NOT NULL,
  PRIMARY KEY (`Aid`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `Academy`
-- ----------------------------
BEGIN;
INSERT INTO `Academy` VALUES ('1', '通信', '4', '0'), ('2', 'ruanjian', '3', '0'), ('3', 'sd', '102', '0'), ('4', 'ffdfd', '202', 'fsd'), ('5', 'fdsdsdggs', '24', 'fs'), ('6', 'fdsfsd', '11', '1');
COMMIT;

-- ----------------------------
--  Table structure for `Person`
-- ----------------------------
DROP TABLE IF EXISTS `Person`;
CREATE TABLE `Person` (
  `Pid` int(11) NOT NULL AUTO_INCREMENT,
  `Pname` varchar(255) NOT NULL,
  `Pimg` varchar(255) NOT NULL,
  `Pacademy` int(11) NOT NULL,
  PRIMARY KEY (`Pid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `Person`
-- ----------------------------
BEGIN;
INSERT INTO `Person` VALUES ('1', '老司机', '1', '1');
COMMIT;

-- ----------------------------
--  Table structure for `User`
-- ----------------------------
DROP TABLE IF EXISTS `User`;
CREATE TABLE `User` (
  `Uid` int(11) NOT NULL AUTO_INCREMENT,
  `Usid` char(10) NOT NULL,
  `Uopenid` varchar(255) NOT NULL,
  `Ulastvote` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`Uid`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `User`
-- ----------------------------
BEGIN;
INSERT INTO `User` VALUES ('10', '2013214368', 'ouRCyjsp3eo3FJil24fV625V_6no', '0');
COMMIT;

-- ----------------------------
--  Table structure for `session`
-- ----------------------------
DROP TABLE IF EXISTS `session`;
CREATE TABLE `session` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `cookie` varchar(255) NOT NULL DEFAULT '',
  `data` text,
  `expire` bigint(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `cookie` (`cookie`),
  KEY `expire` (`expire`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `session`
-- ----------------------------
BEGIN;
INSERT INTO `session` VALUES ('6', '0ZzpwDBrSZJXZDPfJUTHWpLWq5_VYv4n', '{\"openid\":\"ouRCyjsp3eo3FJil24fV625V_6no\",\"carexbs\":1}', '1458279172363'), ('7', 'auZ_0UexcIJD7TqqSiOfXyinyLlz4v3J', '{\"openid\":\"ouRCyjsp3eo3FJil24fV625V_6no\",\"carexbs\":1}', '1458279177297'), ('8', '5Ze_Rjm2JxtR0bPPA14WTa5pLBasevAH', '{\"openid\":\"ouRCyjsp3eo3FJil24fV625V_6no\",\"carexbs\":1}', '1458279526286'), ('9', 'uTGmqRVsWdHsp2wiuKpug9AZoaTGzufl', '{\"openid\":\"ouRCyjsp3eo3FJil24fV625V_6no\",\"carexbs\":1}', '1458279691829'), ('10', 'XzPYG24mJuNeG46wmTaRJ3fODMOwu_b3', '{\"openid\":\"ouRCyjsp3eo3FJil24fV625V_6no\",\"carexbs\":1,\"stu\":\"2014214054\"}', '1458280559017'), ('11', 'iT4_wVY0MpJgtg6Np2D3rZ9k7nTxWGX3', '{\"openid\":\"ouRCyjsp3eo3FJil24fV625V_6no\"}', '1458282710957');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
